SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551057 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551057 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392012,608466,212731,129981,618293,662491,572162,410082,1040481,461811,59578,773712,680411,317443,804841,273453,70044,170203,342142,204932,212568,325336,597806,409262,868514,250857,576038,92961,110178,910935,105186,995165,378146,28408,628562,105253,710011,69561,1024165,970906,1003117,133481,202827,146317,540160,405221,224825,166557,1015804,624919,134150,37321,105574,329626,18351,810482,932962,797775,772550,922977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002546s ]