SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025471 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025471 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632572,968692,236982,370899,605056,32221,117173,165780,439886,724586,508045,84905,621489,399043,555395,1008024,130120,513971,958716,760150,884275,896219,239167,221548,772846,17877,612795,1015476,23820,410452,89448,371248,904746,789205,132894,624855,11666,209360,290235,293523,748291,391545,572488,840973,740074,557454,359848,449292,56724,466118,84813,620891,229715,198706,313638,411814,420122,405687,279189,4115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]