SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298328 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298328 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351653,212261,473901,400099,100594,344747,786589,995628,176908,5669,373029,933865,546938,1031439,1034304,1046956,110989,303514,259434,369184,132305,567489,545474,882030,535061,529655,763902,459680,637397,270781,43215,138214,125313,421235,542746,31419,320305,146939,434269,468179,570103,686509,235406,412372,26862,282057,91976,586159,11475,749990,53938,563345,369675,966913,709161,907830,195288,626838,402045,710790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]