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` = 382914 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382914 [ RunTime:0.002566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35714,799511,483294,248045,791568,311345,990060,183282,856237,532495,98182,152433,191066,789946,110224,621387,758964,891167,36578,231197,1034234,959927,955965,962238,540362,479303,635277,62681,719034,794212,533882,389642,359899,388596,61736,387844,587559,138747,773793,67924,1044004,990799,800205,381569,468578,112017,157802,156439,326880,211153,540431,575270,598245,461675,14830,284425,195078,379505,533737,329038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]