SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545535 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545535 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108890,943447,428836,186591,119624,365458,1023949,896977,152784,846149,549993,991969,790178,420278,227629,358403,475645,32759,187928,877936,1024866,287321,1030368,242261,189200,923907,213056,383999,847440,819589,826465,785872,855560,900002,645469,249413,371966,608645,19418,1044794,310190,980528,461247,110170,129563,419111,124412,632032,143009,358761,744436,612344,488366,959268,473094,709804,941212,840629,954331,785620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]