SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410211 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410211 [ RunTime:0.002641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358152,818147,56118,870962,694786,119884,856322,385985,53426,814442,976712,375665,461423,516535,341970,582830,533181,1035538,673105,791973,871151,467000,820164,773369,1018228,867679,679163,888798,501727,513182,231888,968310,999953,549811,326998,567342,267700,503809,832518,56948,828669,985480,779760,684890,616288,164350,688250,163746,952498,551638,659007,963001,151026,518257,321311,309483,231690,319744,833233,583794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]