SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802308 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802308 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214653,862763,107868,75390,461323,1039836,462519,1037491,892780,482273,322686,820374,62904,316775,399077,58878,344235,117678,76893,480788,18972,720287,711244,850114,507460,893976,457626,661104,757922,436655,247008,918792,732180,547561,337637,476138,887106,332651,69110,855870,579505,365040,840771,641591,185774,839872,1042645,126872,249087,394730,859051,838506,987679,367637,218674,555015,194743,205228,640400,1048402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]