SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496726 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496726 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019218,416606,300721,955574,161100,343077,584584,274701,295154,912431,962610,792316,688186,371091,480155,884701,634325,756095,737148,103177,746335,315551,66906,427560,142163,3012,890509,579863,325606,645458,503965,442623,716894,969106,632717,312244,680978,308185,1029215,80760,442173,413325,100915,226144,915885,64807,973143,781707,2071,1020926,154172,605065,709122,572403,552138,861567,570330,488569,478380,359029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]