SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804082 LIMIT 1 [ RunTime:0.002887s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804082 [ RunTime:0.005538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191437,979017,818373,623655,375076,544850,95263,739322,974860,773924,346037,317183,84468,222626,190029,543426,248343,332894,640362,605827,778358,851375,739540,469729,686237,253544,553121,22147,477659,109230,751176,281278,439298,358557,947024,1014593,910816,901483,99464,969869,204349,34789,548987,470026,134607,688384,649968,204500,879948,761787,213869,621918,267899,746913,572770,221577,291834,693158,743243,120454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001114s ]