SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293176 LIMIT 1 [ RunTime:0.002153s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293176 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252843,1027587,984843,995020,287383,42414,754138,1034515,37690,240792,988850,754576,254119,490872,728447,848530,696050,554066,523099,458927,896347,977311,584289,27464,735544,445968,269216,783947,943176,39133,117085,811098,669842,209406,504365,940265,739959,301566,110428,998569,865179,180022,136698,94794,165140,1015177,956714,890164,565109,951318,1044311,455014,170238,27032,722729,370940,725534,856184,862705,201963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000812s ]