SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001884s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520486 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520486 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65191,267100,1023630,174394,698218,126741,87465,997547,107765,47743,282186,496737,752550,219244,72061,682980,446869,458226,23395,805998,887661,977708,669134,186751,608552,136690,461522,119403,998070,683419,531880,645332,690075,963062,106074,881372,599944,847311,820976,754407,855527,496585,291609,638356,292623,188250,247244,104235,598890,81007,722826,892884,109392,1022396,786615,476850,458795,632472,755507,974241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]