SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045669 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045669 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298833,693174,366992,1019740,763121,534425,378567,241120,497034,733375,102932,1039423,341530,721148,467997,308209,624330,225976,58175,233625,626411,288643,695841,798059,679095,192790,134725,594547,673814,152547,315573,697298,56275,575879,966660,2943,708653,591110,823179,246727,966351,67329,288505,33645,680707,532252,8990,433898,726951,132289,1003408,328025,402515,664990,592163,187172,528146,196316,570718,387519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045669 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045669 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]