SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514623 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514623 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210153,241373,633805,602945,399880,631183,68542,390059,548036,369833,849173,995717,1010972,300520,384030,937236,771665,322019,857354,703637,869099,428759,172033,807720,904161,746793,1017194,272437,520407,302757,199641,518641,23851,407895,850076,78714,975300,579817,957508,726313,469259,1033899,33848,532029,165472,476632,767980,323061,747746,1027879,147502,651785,975440,232158,49431,866519,296242,1043793,61403,626021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001389s ]