SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43767 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43767 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437244,514006,920695,471581,969765,408479,165837,360813,1015560,875784,483482,732141,1040407,225714,519303,337783,419417,416588,977404,849023,991130,19913,496153,4174,282247,603479,308145,118749,142418,170705,480569,208493,865507,683604,1029077,333588,1040744,727136,582136,935925,694426,155758,24178,1008192,413661,264266,225064,1026340,639837,38733,89109,855123,812826,451003,382869,193279,505915,130648,585987,129549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]