SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001826s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045984 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045984 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620659,569729,431420,343806,320181,110057,339930,510319,487560,966279,132632,298557,420299,783816,376161,357533,366486,488403,390954,765456,1029217,855921,968609,601305,469461,66580,568600,452495,405964,875280,777305,262659,595668,440469,896148,659939,755744,869387,190407,39947,865722,1016690,838338,883566,786708,397783,843949,636872,912300,895294,510473,636153,1032565,605995,762915,160104,464990,289297,298543,429083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]