SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31435 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31435 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479266,997370,325210,654184,273210,265760,175964,188220,735208,72749,232357,867582,25254,199689,443105,531481,512534,76068,802795,829663,893146,191704,801283,834408,790594,67394,780388,1038274,1047747,88797,806224,837088,414040,330855,770211,162225,343172,431849,291298,214042,932171,377962,294248,966735,517105,228678,769918,22626,620024,845056,376451,232109,757506,219443,145414,519432,911124,791701,475876,465089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]