SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539241 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539241 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459342,217178,448341,222767,257594,191093,480166,304739,111643,262092,128128,430725,803553,738526,255023,1012608,498255,912082,850066,837071,492840,677210,756362,396677,917198,982033,924282,684471,1017891,292014,390496,187778,606016,872059,843748,290349,754516,464473,47071,704911,537373,895875,534758,34899,312728,800787,773533,892902,625297,893519,439960,119952,541372,32219,956049,445731,414018,332421,772061,300549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]