SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261005 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261005 [ RunTime:0.002247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405373,548342,791894,650595,99477,895422,526039,889199,847602,319536,391540,383791,527795,1027263,736877,993753,913539,374783,152391,614299,1007978,560522,302705,282151,304540,440706,280127,847879,17590,963539,697545,892938,1022350,750396,623804,149090,573903,171835,395307,748485,119791,216748,279645,1042924,878003,175442,592920,665227,867095,200334,239785,591532,159226,17776,356309,517129,815081,59521,660585,25920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]