SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456800 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456800 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466900,632647,872369,411790,464334,455104,558859,921787,686407,549082,209162,902460,927143,765315,624315,378045,669989,87024,349125,880629,713895,1027640,595829,601505,494084,395421,233119,689388,296817,570695,455459,30378,507582,459702,293202,819046,905556,581661,240564,811329,868413,393760,358603,352820,628094,195287,233333,548395,709426,336648,101760,796093,109691,772545,703654,811733,1036448,943032,24790,309968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]