SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505274 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505274 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127550,824205,1032203,582239,136697,543824,147863,432799,815149,285199,484886,600421,539635,291509,901489,465228,639379,640505,530526,725978,583642,126986,776592,83159,931186,647556,938851,487883,630081,843548,203308,539360,645080,885578,509769,154400,271530,190525,281368,997341,837706,547324,178744,262895,762448,357958,791970,586921,652923,683572,139359,753701,950271,82173,680910,960403,695244,858332,9687,984535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]