SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345316 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345316 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033540,304524,929846,186201,801297,919459,986679,540446,547413,901279,486858,899947,441311,178543,914849,894029,489969,497938,696458,757836,1048547,523587,115525,276226,975557,141994,1014458,209721,144438,486663,991510,329593,147587,249988,536752,430307,601089,764122,752046,556418,992146,909787,1046261,510082,535421,756082,855516,793569,326056,655652,132702,764268,687489,545596,348573,814085,150276,347201,254375,21352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005906s ]