SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 669511 LIMIT 1 [ RunTime:0.001295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 669511 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014680,146711,788727,266160,463601,169090,656134,854815,198926,681116,581055,700609,367413,333406,923869,201681,894364,28941,521174,458749,408819,186339,74674,672168,762558,694651,8715,433519,944145,288787,525238,855054,555627,271231,105518,382032,330020,365355,22885,87574,1041357,474438,804471,639154,575148,95289,122017,931073,370590,699810,752219,97098,235075,35293,433257,519678,1027542,354717,400816,40182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 669511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 669511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]