SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029703 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029703 [ RunTime:0.004475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934822,177532,716029,788600,512232,485858,581545,998928,287951,151935,215715,686030,509716,571027,239933,707799,207731,839120,510359,334056,842484,266682,636981,806291,718755,559551,422118,513005,507250,959277,2675,372020,901756,153956,652696,247336,470983,225213,651884,426245,233594,610754,704471,242835,414666,268390,219663,69410,731850,640898,252681,630947,456094,436950,921600,477297,136528,402143,835099,592576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]