SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545094 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545094 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863920,273592,894642,37546,953508,59230,973299,384090,281678,695799,505331,174387,377010,712952,936141,513985,446659,922119,383975,59728,371311,548774,705536,80120,254874,81533,758371,665838,284433,867054,208451,53403,774931,618758,507726,732343,152145,23258,44364,637122,198990,885544,1018141,563987,1010024,579904,660410,778860,841485,525900,122355,48476,412052,605335,218770,180133,615064,689436,52604,965349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003838s ]