SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022017 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022017 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4079,907547,109400,478594,507975,407694,1037142,141559,742416,850122,914084,115343,948468,614970,124443,946148,341998,250840,357242,203876,588593,736665,911688,799194,908411,785669,111062,988433,237803,958647,109014,903306,256823,905806,788849,636364,581523,804801,164526,954111,341575,216615,689211,536360,841731,864349,588642,385970,840042,771534,436497,190951,825917,887114,79506,421008,909613,834273,835468,494175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]