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` = 911118 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 911118 [ RunTime:0.006073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386657,400786,480428,576624,1013938,31856,986974,156149,808000,455844,799229,197474,351849,196638,555864,742936,452892,38182,238938,607534,607316,624049,153847,646188,624506,968223,65839,620197,410305,653398,838,553351,762978,51022,111929,867177,586112,928347,825692,564784,232714,149167,152187,403520,844615,659702,202166,16035,848216,965007,601559,526579,139864,87486,718714,447063,381917,8010,452273,751840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 911118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 911118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000826s ]