SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 605418 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 605418 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831273,40329,448299,539434,419016,687891,610742,80378,1025739,36849,982796,192619,529463,188476,370859,928233,504106,515851,970358,672563,295942,920346,764247,959711,160558,901232,192846,339998,649038,38929,732863,1012223,149998,791078,802760,530771,990085,544303,70888,795423,384328,970475,837574,548718,759902,178884,1007197,618343,113592,901891,354536,379968,119365,895707,155094,853893,365023,670445,602032,381022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 605418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 605418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]