SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531736 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531736 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219105,963973,844635,987843,872204,219155,790423,916315,255974,743834,294232,45589,182177,260698,958364,571970,909190,152699,331275,29847,340423,896779,388403,270057,133564,431813,640861,473164,887039,10475,978543,217597,679096,667924,61333,203241,358599,99480,511003,102845,453019,203597,789937,810757,75054,450862,223743,882803,159817,55223,190388,679475,278366,357308,292607,577626,383630,499578,1002526,513112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]