SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415413 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415413 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173843,409454,284861,451773,252639,1006735,76511,591422,948576,411988,715707,140685,547187,120172,477545,194964,962102,474842,763800,53328,709796,521770,715782,953654,981185,954467,347465,847085,560924,55145,484960,52921,515857,708858,874398,832897,836825,937321,938418,757256,94191,531505,89561,618183,438061,1046053,96922,326082,38275,554875,961002,430748,864157,699628,515750,473222,292048,990976,297689,257829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]