SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101510 LIMIT 1 [ RunTime:0.000704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101510 [ RunTime:0.002814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333947,382968,305770,982151,504321,586917,699534,868527,485914,892788,53016,851932,559007,448373,467834,663808,278506,3245,233346,921396,996419,910590,260750,684807,741556,32568,982232,1018306,539914,211660,762872,888399,910221,910466,738912,39175,263869,1045288,774452,175296,804993,691512,223370,357483,578009,358498,395503,100015,1042854,393451,14171,807797,748530,223625,698001,236919,964241,451208,1047376,264894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]