SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 929810 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 929810 [ RunTime:0.003248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469703,128806,205108,896628,1015483,18529,480822,681267,209059,412086,1027329,887434,285802,674427,921988,537988,642340,595096,1040475,972720,73470,197022,195879,655496,45845,601889,891285,789393,352626,795370,632273,700128,185932,22137,655180,746770,706564,962190,909329,442042,557504,341643,29102,811425,336498,338487,810489,537459,248307,188827,450597,299104,129810,820315,1029694,583606,353228,603054,656346,923870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 929810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 929810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001060s ]