SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 940766 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 940766 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404719,1029538,963936,740888,390753,1001065,81426,180422,786005,891046,994911,1044310,794823,759296,175532,151742,183027,919760,368514,311494,774100,711551,757393,1026486,645479,953913,69573,895281,815631,1014303,495450,804509,173490,803033,957998,489093,43702,611725,391264,830840,713355,1034425,260771,3950,456641,848013,203305,947562,30118,5265,861440,45540,72523,88123,1042836,740104,909413,45817,977215,237260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 940766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 940766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]