SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593210 LIMIT 1 [ RunTime:0.001025s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593210 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474346,3996,751560,397725,135698,165590,87224,171071,375969,885011,298186,170796,150007,986837,1021621,107548,427474,534083,835125,322437,759447,328480,683326,335337,596328,818348,482514,452568,770352,500299,679187,248570,923191,611588,2806,877977,678719,532775,574033,372955,44610,672289,84061,894421,951394,218927,569352,410502,326404,553814,65177,136527,446635,579381,122450,487790,290170,703478,544535,946519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]