SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398834 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398834 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002600,118316,929639,708482,363385,70586,333139,505085,1018107,332377,801328,470251,130078,176195,894523,435859,1011104,956229,1002032,519846,132899,238498,80389,149003,260916,152761,86064,375806,973229,535644,866346,75189,1037486,936622,871813,672773,130701,751001,938383,328182,58791,199368,630524,641417,732057,607763,322687,607588,222156,698218,33467,301331,323667,809310,484844,834327,841587,446167,519649,13835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]