SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413765 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413765 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519060,189680,641154,366812,177424,467291,483342,224561,443455,203983,864731,382783,341525,361075,674274,12570,527897,810131,754616,718659,89205,957184,224033,774847,990175,934426,505762,72471,288626,296595,158180,667291,1008105,331401,122203,869353,937916,974758,275845,702654,703853,643051,453550,553282,576742,473276,291841,352805,994573,312941,629408,826625,244154,448203,1037212,996458,539594,74938,391807,994130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]