SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404454 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404454 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005393,391182,359706,772190,280951,1032560,721510,12317,110039,185787,996456,157641,542237,865514,451962,248594,496387,352703,258976,197961,542817,273315,676786,532938,833347,750773,978329,26186,872362,376516,419994,592060,605286,402288,992847,801226,613255,218393,495696,633748,597973,612741,915232,102360,772907,147814,134816,395444,568175,386985,390457,1023070,603017,953834,385354,838388,19028,701510,596686,701280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001633s ]