SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417343 LIMIT 1 [ RunTime:0.001007s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417343 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335038,1003396,49590,573818,879754,456419,729575,640911,145701,545170,1002068,866584,89187,659403,406733,859846,932576,387640,942481,759705,289822,190708,833595,968292,775833,828009,860003,540199,574569,595236,39139,369858,814023,107431,673087,547763,687940,66799,913883,930060,879622,913456,29519,809664,82656,460019,593449,690737,684231,583365,970624,1041040,79481,897463,734598,756726,838307,752633,375493,141018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]