SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296100 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296100 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108358,1013827,2377,1040636,484309,1018699,376402,705593,360652,237229,467712,1023646,384159,495460,178322,51769,191529,996218,563563,503517,87502,396209,187351,225468,567883,80093,741816,895878,41532,357664,117553,954444,577898,1015643,638746,386401,104873,43251,892101,73740,1035893,38323,611324,779868,1032725,811340,116056,44162,944756,296238,368204,360323,356948,829242,385117,842439,787846,472766,165849,961029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]