SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417804 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417804 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658022,156609,785401,927636,193185,472969,577908,488002,72129,730980,248067,849165,464150,937425,132891,767650,350731,942284,82246,820648,480700,951303,229599,1021396,42426,1020927,1001490,212978,160058,170862,457913,643137,423176,844693,748634,304599,22974,724532,38737,319288,438087,991979,646708,159639,905658,87571,416124,834819,59212,475057,178217,298947,857471,940140,135152,987569,542008,365265,521118,457624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]