SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567706 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567706 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838116,936233,592998,777620,858501,534298,496549,453615,955872,913698,970775,508283,658705,134667,442358,789610,1002486,838743,179656,409862,345886,983430,179281,186821,339416,907470,267812,827871,537820,696386,678707,628284,675741,1025792,82267,1012910,549122,91288,364813,933144,169604,285047,933859,1000340,1033202,12106,629317,563561,431269,577149,242706,557892,47083,402645,445283,667365,235393,945259,352975,770778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]