SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 659499 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 659499 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520139,814492,490399,408240,834179,689368,917509,1041888,425224,20848,910915,819423,287660,142214,393225,932195,23460,938932,541410,275762,829761,686386,237367,3576,513122,994068,862501,451591,132881,910746,882844,494539,661348,349668,438814,388861,853116,370816,1034159,589817,250172,462345,682666,405240,736811,438993,351206,807569,527044,870553,686134,212399,459738,405783,852571,14036,615726,934102,290262,244066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 659499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 659499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]