SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140083 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140083 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381473,341447,700273,533485,946594,491159,791578,586878,1023,82543,29217,648680,228101,351774,76376,210831,613900,10429,303114,283899,259525,314324,646200,319187,346658,497934,186700,191923,872686,763029,599061,138088,183162,887188,1042354,287931,643794,416290,532747,327400,523939,645997,921256,361875,474767,723043,35975,846697,47264,502429,418694,756192,207224,829664,334572,706401,453391,279005,161935,468910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]