SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201046 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201046 [ RunTime:0.003634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7399,804254,130596,524280,798974,208389,390582,256416,995467,260756,758228,947298,948778,503779,548757,799287,259810,35643,992207,833172,108548,787236,372963,41819,355294,203104,458306,1024637,517638,241888,25327,543473,287577,230962,31682,598889,610861,472412,454820,936886,519407,580346,956165,762851,963653,361140,49356,540889,40398,250929,552574,1043046,901387,1043428,865511,761878,524960,780197,399516,864814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]