SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325181 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325181 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442690,815957,6364,489672,248975,816061,573585,950430,45292,533457,238246,218572,913606,611800,772076,659451,536176,962624,198763,963285,895747,446574,222050,576391,480970,551971,881959,347082,130809,495290,577476,889708,441300,210617,657561,925861,550137,394733,682111,495829,174848,736882,959025,263633,281166,386300,966647,344709,772773,647283,269530,67438,799518,602257,785782,871414,150019,254928,443376,607135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]