SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80138 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80138 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763030,633077,57098,468234,444280,12961,415048,834592,121582,599204,258606,946300,225584,444832,218795,479697,591896,383295,366713,567374,397296,841627,303588,724202,363125,196470,913095,151677,645212,130190,230404,817954,640316,37967,790855,773822,702816,754915,960124,748481,747341,832464,509746,530427,69744,967568,487733,267535,404566,659536,516276,906575,324348,406954,941426,48599,284436,634409,249026,826470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001804s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001448s ]