SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002827s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048114 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048114 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911110,855925,6486,140526,96984,490109,179793,829859,271270,478963,37159,150388,471816,151364,905734,118202,170207,210654,972381,1031574,150747,807185,366505,912514,574758,433838,156409,391066,86990,525385,530099,215173,884842,92996,829618,633966,37068,570855,193216,249995,651395,1037372,409794,851864,989857,211673,976731,337023,290321,935780,81509,517728,526574,120421,740425,88407,159384,477681,800848,275147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]