SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019957 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019957 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563763,586650,754836,654203,947979,347394,461596,360271,611523,738949,273967,913478,15173,27847,870499,829692,88568,953253,854967,124462,595337,1024457,458182,331040,435648,533384,548402,521537,691278,299789,362605,609613,234490,74249,592395,788585,53736,491900,164025,296219,66085,785487,686610,170643,437306,94956,867581,37226,390063,208154,274380,278377,68566,939550,571139,807444,899204,265034,785338,461610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]