SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464943 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464943 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48448,963601,826662,183356,466415,518494,411727,401500,919980,600919,331917,248659,315616,120042,221795,483923,869103,277870,179888,495746,180950,842525,331837,868448,757881,846824,634706,625366,690243,260162,1040843,837818,808037,324237,514289,140424,893979,459868,220856,8377,305918,534880,662948,662309,141480,1036798,812217,93611,921049,148013,31153,642331,344721,1037645,431178,550663,260224,894437,530750,253732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]