SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516023 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516023 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118944,350261,115651,21205,482769,495405,13096,732083,120897,1019819,987912,977675,139687,636935,491918,633153,626299,266183,341228,145685,495265,235158,288832,960266,37526,323856,175646,1018672,243304,541284,699780,1034252,394308,1014069,1017385,433531,718307,446720,230806,612101,934724,295165,725131,65126,284333,462358,715337,708043,59915,700869,958795,101769,108080,101694,1002103,459789,473042,382616,121335,982260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003369s ]