SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511452 LIMIT 1 [ RunTime:0.001643s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511452 [ RunTime:0.004648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7342,284437,1016917,520091,144261,172866,893280,389839,812064,521753,71158,545511,725586,795127,680118,56883,641891,699650,196765,66525,145240,993739,1041446,894584,989361,802500,809429,355185,46283,811395,526372,13740,662597,248255,327670,4308,613865,18020,915197,824243,351828,205077,502920,185645,1046063,77061,569968,335573,292841,686229,388832,770462,1030483,168426,538290,164163,851586,825474,755955,342807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001474s ]