SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34771 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34771 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7164,142761,697779,405262,711535,464803,655134,957399,109549,189272,95650,785262,472519,62012,537270,513453,321916,888728,387006,763684,698816,752081,951114,439620,444192,542958,517217,140280,689532,946121,145448,695461,443410,754996,421498,144846,856625,328028,268044,11667,281127,983424,558042,980999,956511,573525,92757,130000,290448,93909,151819,588697,233298,420126,490090,680181,172203,167394,709682,721687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]