SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536654 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536654 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873070,247560,678435,457718,82179,504132,911503,149727,353402,305128,801722,347122,812230,129720,51088,603422,69376,961040,774504,730502,469656,794424,1024546,668010,833400,489921,396514,824983,943941,271743,176882,716412,686377,884478,860400,682878,814340,289674,848281,890784,254949,870238,127589,776643,896809,330848,186561,876494,550223,864062,470854,450557,486990,1040722,882746,352956,266142,636161,447362,474191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]