SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266421 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266421 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356782,962854,1044442,354890,28680,41836,792415,944194,414897,855764,211398,837373,807495,427967,951455,354014,786822,201353,977629,550781,335958,636746,994303,102910,639407,564243,359813,150487,239385,174367,850879,184156,655252,162178,949889,889848,887605,139730,283284,420120,896163,326133,742929,786180,882945,912645,211230,420285,228874,608884,30268,909144,773659,459076,735625,223276,623644,309303,49650,836909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]