SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517252 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517252 [ RunTime:0.002558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537161,227501,757380,98600,194498,709059,45916,1034149,804572,222722,716684,475419,494761,557574,552191,942630,36400,268036,618575,581898,577570,937487,21765,1037117,957181,1013152,286388,721695,492981,777349,774985,1041849,346796,981787,125751,345780,867190,994130,724974,653805,1028791,208203,389242,873910,1048426,656850,407925,717622,425532,812503,874545,652130,928541,332532,509839,654876,621646,956881,40896,138266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]