SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108817 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108817 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248482,107797,871199,771990,801691,537128,1008644,171969,914331,817196,553311,366173,733345,380708,679001,21151,728868,925102,916352,843541,881971,672665,134466,650629,73185,871030,458732,226162,962502,232478,564036,539204,439658,740067,47649,462111,518008,648755,276159,870492,72170,349999,529289,476743,105278,712544,748637,211617,868316,830763,849160,209835,113442,572801,154799,785900,708585,222668,583656,844251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]