SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 155912 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 155912 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503529,111581,147647,105275,97691,156083,136950,702295,916712,797739,11415,794337,832259,79960,203533,753803,700734,938612,124775,265102,914922,651911,519608,915053,966738,976646,101730,213952,852045,785579,1011840,663035,184434,707412,656434,165514,80600,893196,627595,1020412,84492,243995,279633,969654,842372,593883,878650,510103,888221,1020544,560254,7169,944917,630068,647555,32120,537689,847070,296132,224698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 155912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 155912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]