SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349753 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349753 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455037,792155,543817,175520,1010349,948841,467506,280336,319095,900842,750534,484526,402594,915560,785751,442373,884028,434072,879539,1005442,896977,111873,121139,189152,773712,440562,686132,965287,18662,960476,843100,928627,984958,753264,1040952,105891,391063,965913,635003,486946,209931,889451,652376,466426,160820,101337,468856,644197,541816,769010,189027,687328,590659,460963,102391,192375,736969,315735,1044125,954262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]