SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205189 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205189 [ RunTime:0.003151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328736,15034,510088,637896,13443,810778,741220,530999,619535,33755,644455,331640,572084,164271,627150,59144,205570,527956,247192,711696,392041,977974,827764,333239,95464,709456,334215,229187,385525,137038,552674,309235,990372,257493,956109,424538,956774,852540,1045788,947816,795256,974094,633633,838486,773891,147812,590281,102284,874650,271691,790805,128090,974587,119151,142397,1035030,502166,188607,623893,683743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]