SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517041 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517041 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312022,619112,683903,428166,236198,445539,121467,906793,736124,492178,116519,178483,61487,743507,830455,329170,858480,68673,310305,725364,310258,149711,1003031,66923,646423,1042932,402820,530683,1023233,690222,751701,836452,355558,651015,64390,521103,670127,812726,330564,401494,165345,232040,350070,264454,724342,1025876,353989,932721,571033,139486,292466,970562,52126,962298,354636,191801,959150,959983,963544,418736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]