SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001701s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407591 LIMIT 1 [ RunTime:0.001538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407591 [ RunTime:0.002603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289579,428837,422613,422811,624320,871782,278919,188144,586977,394356,1023839,678376,1006997,773778,669570,683423,267529,544348,206309,601248,664555,77746,370972,851661,193854,41700,10557,566243,996488,918811,778657,784624,591635,458681,570272,655394,290842,678647,373059,211667,1011431,738087,222535,768710,990899,435413,640983,239577,526383,154406,695668,115411,92380,844097,796676,763850,1011814,583347,812055,930522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]