SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503212 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503212 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191464,317705,477018,507590,1028944,779289,793341,986175,56120,24698,1043555,898366,562896,783660,475080,574441,897356,535724,965016,714941,853431,395093,480993,759558,1022477,355910,136198,477567,606112,609400,280766,898465,669239,189055,953063,321351,401719,963241,267598,586961,784114,360668,188970,332902,979612,679058,303107,11045,257899,19701,814122,872384,3694,172173,765047,730916,473628,338248,413326,787797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]