SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28110 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28110 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106523,533564,75635,933587,727778,30349,309184,50774,283790,963102,985591,744585,835281,960679,612684,867948,633467,824407,857505,500051,672513,592060,823538,970531,72657,809883,353624,817471,778526,394010,556577,468853,667808,742199,457769,2997,390340,606404,136307,551062,713351,21282,173441,714477,107944,489748,819041,539151,435699,529460,698012,252401,341283,796208,378192,802880,817988,132798,89959,643158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]