SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516316 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516316 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181259,660568,173300,780262,351713,1022686,913533,869547,827018,348404,125269,835719,180862,102557,111456,381509,418292,539795,112309,1024451,163465,587642,973273,405832,143117,195835,671845,797794,637936,628009,190384,865744,864677,590619,238227,526759,894246,857008,391597,825043,285957,754022,590915,490189,242475,455805,80251,887046,834651,897892,363426,506842,380701,540296,589773,752397,234675,337242,422745,261227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]