SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507743 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507743 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723634,207270,78517,583264,892729,236007,665074,378820,150925,874796,1698,118199,192027,725775,887967,1007643,504264,1014393,624120,849576,377664,304656,294377,1015711,755336,993391,838731,402464,304174,272589,475888,533076,706754,732093,218887,844209,289645,650811,135661,223953,149839,52102,47235,822240,86083,818131,126289,910740,1034138,688531,367749,365773,125677,133241,461877,311941,583170,628270,881783,599291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]