SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501898 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501898 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640341,498944,1035395,422515,256439,265642,16584,1023628,488839,378982,851197,124232,891616,265373,110282,693211,1027829,836731,710656,623487,911735,474394,628401,23391,430827,372559,668565,157817,867628,65046,21241,449375,215519,271270,845639,859434,349698,74057,664083,489647,398798,113754,839842,855075,423851,408508,589210,733155,4653,808533,897611,157765,833004,82924,803209,839082,478521,499706,591545,965557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]