SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260983 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260983 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692508,630746,452938,523530,224529,686323,284190,254680,851033,240046,880947,727911,443674,549714,841782,485829,1021725,175120,717512,59649,270091,588394,120449,419023,592107,412160,446320,277135,45647,955245,1048075,272620,256789,726617,470960,923226,526061,211599,463437,167385,112948,902754,711256,918011,203201,142659,597811,254270,555449,340461,408904,776627,269204,891843,840320,580916,593262,219546,589621,638509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]