SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4321 LIMIT 1 [ RunTime:0.000268s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4321 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172093,47223,220867,88661,12240,948813,202530,169288,357719,573680,773549,858369,1046322,595318,416802,853838,328524,887395,456485,159756,307264,531546,859373,374163,1006216,584925,29048,141645,450898,572273,266630,844704,513070,730295,882767,1020571,876195,279489,522214,89023,55849,725768,999032,517424,710111,375184,872885,142308,663846,225700,677033,708098,274434,1040552,947190,695168,109001,726434,232918,314806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001926s ]