SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253283 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253283 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415302,852033,529727,151797,727969,27942,921494,824925,758541,758767,831944,298576,720565,546977,534158,100191,339644,73745,492827,908729,72580,341042,249489,518484,896751,827518,309821,98313,147736,712139,1031016,612178,668134,32188,291139,549676,577843,410958,86930,36130,277915,774051,393587,170269,979933,201106,534399,785600,100033,567185,915045,516359,267809,537928,759640,879737,594885,407424,129233,580337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]