SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406912 LIMIT 1 [ RunTime:0.001456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406912 [ RunTime:0.005464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827828,571989,479941,538892,648778,329972,1004663,581303,1008599,983848,489101,1014262,868543,872498,667894,798677,118480,52627,290105,667794,21069,151331,646596,311466,213668,1710,165600,794674,89790,450316,284701,802591,401039,905327,901707,438892,923430,383744,773785,646288,190781,147581,842943,1031677,579483,470589,75077,706703,505080,628165,865568,977524,247674,697984,152978,851268,3670,159905,54579,134444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001304s ]