SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001893s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504919 LIMIT 1 [ RunTime:0.002460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504919 [ RunTime:0.004124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392750,192552,814919,580264,1033550,322514,598004,357444,155610,28776,411883,605757,264446,264317,196022,819659,782174,241279,864199,652723,113986,127112,849828,919017,433896,44402,196466,96765,506151,625142,559466,262467,614813,413299,789375,691441,953297,251459,638470,844692,965811,291517,352784,1019724,1031294,24354,679034,221817,151412,738129,805730,914524,99731,212091,343373,464954,216642,266642,178772,905778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003402s ]