SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309286 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309286 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183178,103498,86709,315081,665944,803743,995876,623581,883929,654051,802458,123849,1017383,403228,430387,262127,316799,10579,746568,969686,1022216,821905,540076,26960,136405,712990,237469,161082,651436,190288,1037732,128769,457571,22112,940511,239844,553180,197813,960061,274304,163248,458480,110278,58512,41103,19926,695210,755731,662279,352766,481306,995047,568469,752447,382147,839672,383104,531600,398973,281935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]