SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518839 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518839 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67008,429135,398968,844201,281683,359388,789239,505045,412285,221737,16486,644892,649189,991343,188295,81218,382869,233960,822031,386273,585770,511963,75233,628865,63227,450716,452512,122214,966365,798701,921950,321465,960197,989009,655257,514841,114908,542091,281534,218705,1037575,581629,665537,268641,419612,577088,647080,852041,452523,975664,210508,891297,777669,687706,312758,797499,143192,557750,544940,43745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002272s ]