SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39454 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39454 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522513,395519,157664,416632,667765,826131,375488,918131,381169,56564,135743,647660,835163,534456,624594,38576,355925,962173,61500,659579,722516,105862,457756,993310,81063,60081,223337,39066,326226,863566,819568,695577,1039671,870331,1038337,129970,768712,240684,956528,193075,701812,737243,434569,823125,744426,152007,703742,607428,190227,1031501,751751,960051,489648,340665,735611,570831,370018,232707,769084,158367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]