SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201070 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201070 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644166,439549,814175,873355,692739,961306,627779,781442,489945,461394,459006,663429,199102,262789,1040178,830066,65376,8935,620537,949465,374940,571022,398004,574482,679277,721901,239789,820541,701611,873580,175869,394968,134648,14703,394289,780164,650984,462069,604749,843736,521071,814939,482243,118323,118680,278538,1020324,38681,58641,787158,59492,275393,644945,669725,248348,299597,650807,103705,381739,580106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]