SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451918 LIMIT 1 [ RunTime:0.002667s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451918 [ RunTime:0.011013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639229,317989,508363,918279,1015362,114406,1012893,583727,501044,745649,1041995,384995,191807,857049,850144,434490,228020,384999,298084,673648,220309,1029629,515700,602609,534566,875576,417662,525232,764569,431026,321307,894089,542961,623558,250446,935267,429434,22343,4784,911274,538370,964717,287315,435980,455120,580074,151480,36050,1193,288354,54946,842287,531995,642541,431310,229126,553078,236867,136464,230184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]