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` = 101194 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101194 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499491,2976,49024,166646,304153,737819,60150,510319,173042,430781,408090,743521,193537,916102,610556,870319,630763,239425,445378,591652,442474,1031184,175553,753137,1037786,552916,38080,992683,211645,581116,199467,724913,631976,55447,720351,766465,974758,211627,774762,746371,520515,929068,210172,868095,961060,559308,508086,987522,374413,830270,649144,927771,159027,112330,706101,767927,467897,893617,73759,163623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]