SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500448 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500448 [ RunTime:0.003323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723577,493087,962304,193453,364052,303161,1028152,460717,547176,405679,179548,65762,718928,318490,357552,560251,573009,556145,917096,427492,544103,564545,526385,802976,901917,842841,907749,261717,460616,437946,561417,781565,941750,96319,973649,150661,9100,210221,711224,929492,49220,41170,792477,113422,807333,537374,779591,215521,41177,159628,723939,448012,315976,817027,846914,461489,189635,551331,575813,516201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]