SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499029 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499029 [ RunTime:0.002689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246332,588006,335385,759130,793456,214889,110246,139160,879748,981362,238637,190232,1043770,517266,892034,316023,120483,437823,573276,114314,522777,924889,775398,626885,878832,293673,881547,82109,822056,229848,671537,180894,323924,414665,175934,57675,251819,1002170,431463,828831,127389,296281,769487,382015,866616,288032,767741,686209,408539,796191,220617,58450,815596,352741,363040,165056,802003,913301,732079,249108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002306s ]