SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432100 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432100 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422569,431620,1034145,490195,280485,159763,935818,828035,238518,222875,490556,936616,523016,441710,674386,344241,719067,295011,879343,334119,456746,489489,414973,515613,524645,608868,564023,117054,1023877,406596,949905,907379,872792,776299,471229,159832,52166,535443,506901,390815,648636,808559,273833,977200,360923,921782,403222,684898,442908,250081,313851,411415,607849,85138,963818,302102,594324,102268,207619,1020430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001696s ]