SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314580 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314580 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246756,742684,718878,568219,1033243,294828,50618,100833,126450,483555,662271,795188,632621,232226,1031577,874156,695891,905370,522785,578213,591732,80560,424818,917258,521761,892387,589543,250704,619190,328912,676596,883150,148296,533587,1037961,341496,655753,136713,667827,455520,763885,914702,1000490,991971,770564,223750,430926,870889,735511,994822,726712,202274,954417,434427,60642,645538,143949,173603,319021,225976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]