SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482307 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482307 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879424,174872,914424,494771,720092,177211,407804,566914,798770,130990,346407,452267,158597,619543,645614,220303,33470,178473,268878,462664,327638,466356,820866,431224,325548,240259,746141,1045049,405541,231479,25739,939967,883018,1017004,843860,20383,514389,223909,567431,709424,743053,968174,152305,983710,770584,523658,661022,48912,400318,438088,92106,287190,122936,563992,544695,956852,496031,711473,715775,814779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]