SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41818 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41818 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311674,314884,938936,139376,751560,80148,387349,904707,139188,380653,562522,285392,347658,681320,738614,496075,100464,679582,619264,909016,187699,638146,926274,921706,188163,965484,861642,332037,4268,500227,585290,739267,101721,658037,113826,936066,319737,304818,344409,319019,58014,673873,54126,933074,250189,410504,427559,460511,509036,314927,461656,125307,198625,737393,707558,321141,765787,733215,1023708,430597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]