SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433708 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433708 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899711,801763,1035406,665202,638207,300673,318599,687544,875632,267401,159969,799624,677683,64571,774685,10483,408239,605328,723380,806892,59593,88338,680018,593623,143330,732916,834995,752980,934897,691493,566520,308064,459796,218857,908214,311196,971073,532969,64873,85427,81842,803160,634535,212184,43223,822322,452131,743213,58499,1004757,752677,819689,759482,513396,629984,776453,264698,522441,971192,962548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]