SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587513 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587513 [ RunTime:0.003120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033616,149801,344347,150845,202754,153256,545637,240028,164819,204435,501057,480709,503817,929451,455812,265806,592462,343539,453001,30412,293713,499929,646149,243115,615282,217784,200386,378385,374925,328444,358162,418765,19233,760049,300236,698889,145304,438746,845030,1023420,404554,704830,393970,81433,623426,825372,643989,112066,457783,495735,537475,345006,389324,895485,245651,767619,353010,930992,706948,912448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]